USE [master]
GO

create database ShipLinkCentralDB
GO

/* For security reasons the login is created disabled and with a random password. */
/****** Object:  Login [ShipLink_User]    Script Date: 7/1/2020 12:32:20 AM ******/
CREATE LOGIN [ShipLink_User] WITH PASSWORD=N'ShipLinkSLC123', DEFAULT_DATABASE=[ShipLinkCentralDB], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

USE [ShipLinkCentralDB]
GO
/****** Object:  UserDefinedFunction [dbo].[ufn_SLCCaseNumber]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[ufn_SLCCaseNumber]()
RETURNS varchar(8)
AS
-- Returns the custom Case Number, length of 8 digits
-- Format is YY000001
BEGIN  
    DECLARE @caseNo varchar(8);
 --get latest case number
 Set @caseNo = (Select TOP 1 CaseNumber From [SLCShipmentPackage] Order by Id Desc);
    
 IF (@caseNo IS NULL) 
  SET @caseNo = Right(Year(getdate()), 2) + '000001';
 ELSE
  Begin
   declare @year varchar(2);
   declare @num int;
   set @year = LEFT(@caseNo, 2);
   set @num = Cast(RIGHT(@caseNo, 6) as int);
   IF (@year <> Right(Year(getdate()), 2))
    --reset number to 1 if year is changed
    SET @caseNo = Right(Year(getdate()), 2) + '000001';
   ELSE
    --increment the number for current year
    SET @caseNo = @year + Right('000000' + cast(@num+1 as varchar), 6);
  End
  
    RETURN @caseNo;  
END;
GO
/****** Object:  Table [dbo].[EODSiteClose]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EODSiteClose](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SiteId] [varchar](50) NOT NULL,
	[IsClosing] [bit] NOT NULL,
	[StationId] [varchar](50) NOT NULL,
	[InitiatedAt] [datetime] NOT NULL,
	[IsFormula] [bit] NOT NULL,
	[FormulaName] [varchar](200) NULL,
 CONSTRAINT [PK_EODSiteCloses] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[EODSiteCloseDetail]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EODSiteCloseDetail](
	[Id] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
	[EODSiteClose_Id] [bigint] NOT NULL,
	[EODShipmentInformation_Id] [bigint] NOT NULL,
 CONSTRAINT [PK_EODSiteCloseDetail] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLASN]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLASN](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[IsDeliveryNotify1] [bit] NOT NULL,
	[ShipFromCompany] [varchar](50) NULL,
	[SubjectLine] [varchar](75) NULL,
	[Memo] [varchar](150) NULL,
	[PackListSubject] [varchar](100) NULL,
	[FailedEmailAddress] [varchar](50) NULL,
	[IsNotify] [bit] NOT NULL,
	[IsNotifyStr] [varchar](50) NULL,
	[IsShipNotify1] [bit] NOT NULL,
	[IsPackList1] [bit] NOT NULL,
	[IsExceptionNotify1] [bit] NOT NULL,
	[IsInTransitNotify1] [bit] NOT NULL,
	[NotifyCompany1] [varchar](50) NULL,
	[NotifyContact1] [varchar](50) NULL,
	[EmailAddress1] [varchar](500) NULL,
	[PackListEmailAddress1] [varchar](500) NULL,
	[NotifyTelephone1] [varchar](15) NULL,
	[IsShipNotify2] [bit] NOT NULL,
	[IsPackList2] [bit] NOT NULL,
	[IsDeliveryNotify2] [bit] NOT NULL,
	[IsExceptionNotify2] [bit] NOT NULL,
	[IsInTransitNotify2] [bit] NOT NULL,
	[NotifyCompany2] [varchar](50) NULL,
	[NotifyContact2] [varchar](50) NULL,
	[EmailAddress2] [varchar](500) NULL,
	[PackListEmailAddress2] [varchar](500) NULL,
	[NotifyTelephone2] [varchar](15) NULL,
	[IsShipNotify3] [bit] NOT NULL,
	[IsPackList3] [bit] NOT NULL,
	[IsDeliveryNotify3] [bit] NOT NULL,
	[IsExceptionNotify3] [bit] NOT NULL,
	[IsInTransitNotify3] [bit] NOT NULL,
	[NotifyCompany3] [varchar](50) NULL,
	[NotifyContact3] [varchar](50) NULL,
	[EmailAddress3] [varchar](500) NULL,
	[PackListEmailAddress3] [varchar](500) NULL,
	[NotifyTelephone3] [varchar](15) NULL,
	[IsShipNotify4] [bit] NOT NULL,
	[IsPackList4] [bit] NOT NULL,
	[IsDeliveryNotify4] [bit] NOT NULL,
	[IsExceptionNotify4] [bit] NOT NULL,
	[IsInTransitNotify4] [bit] NOT NULL,
	[NotifyCompany4] [varchar](50) NULL,
	[NotifyContact4] [varchar](50) NULL,
	[EmailAddress4] [varchar](500) NULL,
	[PackListEmailAddress4] [varchar](500) NULL,
	[NotifyTelephone4] [varchar](15) NULL,
	[IsShipNotify5] [bit] NOT NULL,
	[IsPackList5] [bit] NOT NULL,
	[IsDeliveryNotify5] [bit] NOT NULL,
	[IsExceptionNotify5] [bit] NOT NULL,
	[IsInTransitNotify5] [bit] NOT NULL,
	[NotifyCompany5] [varchar](50) NULL,
	[NotifyContact5] [varchar](50) NULL,
	[EmailAddress5] [varchar](500) NULL,
	[PackListEmailAddress5] [varchar](500) NULL,
	[NotifyTelephone5] [varchar](15) NULL,
 CONSTRAINT [PK_SLASN] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCDocument]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCDocument](
	[Id] [bigint] NOT NULL,
	[DocumentName] [varchar](50) NOT NULL,
	[CreateDocumentIf] [varchar](50) NOT NULL,
	[IsProcessingFormula] [bit] NOT NULL,
	[ProcessingFormula] [varchar](50) NULL,
	[Output] [varchar](50) NOT NULL,
	[OutputType] [varchar](50) NOT NULL,
	[FilePath] [varchar](50) NULL,
	[EmailTemplate] [varchar](50) NULL,
	[TargetFolder] [varchar](50) NULL,
	[NoOfCopies] [int] NULL,
	[TargetPrinter] [varchar](50) NULL,
	[OrderMethod] [varchar](50) NULL,
 CONSTRAINT [PK_EventDocument] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCEmailDetail]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCEmailDetail](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SLCShipmentByOrder_Id] [bigint] NOT NULL,
	[OrderId] [varchar](50) NOT NULL,
	[ParentOrderId] [varchar](50) NULL,
	[ShipDate] [datetime] NULL,
	[LineNumber] [decimal](4, 0) NOT NULL,
	[LineType] [varchar](1) NULL,
	[PartNumber] [varchar](50) NULL,
	[CusPartNumber] [varchar](50) NULL,
	[PartDesc] [varchar](50) NULL,
	[SKU] [varchar](50) NULL,
	[Warehouse] [varchar](50) NULL,
	[OrderQty] [decimal](18, 3) NULL,
	[ShipQty] [decimal](18, 3) NULL,
	[BackOrderQty] [decimal](18, 3) NULL,
	[ItemPrice] [decimal](18, 3) NULL,
	[ItemDiscPrice] [decimal](18, 3) NULL,
	[ItemCost] [decimal](18, 3) NULL,
	[ItemUom] [varchar](3) NULL,
	[ItemShipClass] [varchar](50) NULL,
	[ItemWeight] [decimal](18, 3) NULL,
	[ItemVolume] [decimal](18, 3) NULL,
	[TotalLineCharge] [decimal](18, 3) NULL,
	[TariffCode] [varchar](25) NULL,
	[TaxCode] [varchar](50) NULL,
	[TotalLineCost] [decimal](18, 3) NULL,
	[CountryOfOrigin] [varchar](50) NULL,
	[NMFC] [varchar](50) NULL,
	[FreightClass] [varchar](50) NULL,
	[IsSerialNumberReq] [bit] NULL,
	[BOMFlag] [varchar](1) NULL,
	[ProductClass] [varchar](50) NULL,
	[IsTaxable] [bit] NULL,
	[Custom1] [varchar](200) NULL,
	[Custom2] [varchar](200) NULL,
	[Custom3] [varchar](200) NULL,
	[Custom4] [varchar](200) NULL,
	[Custom5] [varchar](200) NULL,
	[Custom6] [varchar](200) NULL,
	[Custom7] [varchar](200) NULL,
	[Custom8] [varchar](200) NULL,
	[Custom9] [varchar](200) NULL,
	[Custom10] [varchar](200) NULL,
	[AltPrice] [varchar](50) NULL,
	[Bin] [varchar](50) NULL,
	[CaseCode] [varchar](50) NULL,
	[CaseHeight] [decimal](18, 3) NULL,
	[CaseLength] [decimal](18, 3) NULL,
	[CaseWeight] [decimal](18, 3) NULL,
	[CaseWidth] [decimal](18, 3) NULL,
	[Ecc1] [varchar](50) NULL,
	[Ecc2] [varchar](50) NULL,
	[Ecc3] [varchar](50) NULL,
	[Ecc4] [varchar](50) NULL,
	[Ecc5] [varchar](50) NULL,
	[FreightCharge] [varchar](50) NULL,
	[HazardousCode] [varchar](50) NULL,
	[HazardousType] [varchar](50) NULL,
	[HazardousUom] [varchar](50) NULL,
	[HazmatCustom1] [varchar](50) NULL,
	[HazmatCustom2] [varchar](50) NULL,
	[Height] [decimal](18, 3) NULL,
	[InitLineNumber] [varchar](50) NULL,
	[IsCase] [bit] NOT NULL,
	[IsFreightCharge] [bit] NOT NULL,
	[IsHazardous] [bit] NOT NULL,
	[IsItemLotNoReq] [bit] NOT NULL,
	[IsItemSerialNoReq] [bit] NOT NULL,
	[IsKit] [bit] NOT NULL,
	[IsMiscCharge] [bit] NOT NULL,
	[IsServiceCharge] [bit] NOT NULL,
	[ItemCustom1] [varchar](50) NULL,
	[ItemCustom2] [varchar](50) NULL,
	[ItemCustom3] [varchar](50) NULL,
	[ItemCustom4] [varchar](50) NULL,
	[ItemCustom5] [varchar](50) NULL,
	[ItemDiscPrice1] [decimal](18, 3) NULL,
	[ItemPackagingType] [varchar](50) NULL,
	[ItemPrice1] [decimal](18, 3) NULL,
	[ItemPriceCode] [varchar](50) NULL,
	[ItemShipClass1] [decimal](18, 3) NULL,
	[KitType] [varchar](50) NULL,
	[Length] [decimal](18, 3) NULL,
	[ManuCountryCode] [varchar](50) NULL,
	[Nafta1] [varchar](50) NULL,
	[Nafta2] [varchar](50) NULL,
	[Nafta3] [varchar](50) NULL,
	[Nafta4] [varchar](50) NULL,
	[Nafta5] [varchar](50) NULL,
	[SpecialHandlingFlag] [varchar](50) NULL,
	[SYS_MConvFactOrdUm] [varchar](50) NULL,
	[SYS_MDiscValFlag] [varchar](50) NULL,
	[SYS_MDiscValue] [varchar](50) NULL,
	[SYS_MFstTaxCode] [varchar](50) NULL,
	[SYS_MItemDisc1] [varchar](50) NULL,
	[SYS_MItemDisc2] [varchar](50) NULL,
	[SYS_MItemDisc3] [varchar](50) NULL,
	[SYS_MMulDivPrcFct] [varchar](50) NULL,
	[SYS_MPriceUom] [varchar](50) NULL,
	[SYS_NComment] [varchar](500) NULL,
	[SYS_NCommentFromLin] [varchar](50) NULL,
	[SYS_NCommentTextTyp] [varchar](50) NULL,
	[SYS_NCommentType] [varchar](50) NULL,
	[TraceableFlag] [varchar](50) NULL,
	[UpcCode] [varchar](50) NULL,
	[Width] [decimal](18, 3) NULL,
	[IsHazMat] [bit] NOT NULL,
	[IsHazMatOrmd] [bit] NOT NULL,
	[HazMatCode] [varchar](50) NULL,
	[HazMatDesc] [varchar](50) NULL,
	[HazMatUom] [varchar](50) NULL,
	[HazMatQty] [decimal](18, 3) NULL,
	[AltDesc] [varchar](200) NULL,
	[IsCommodity] [bit] NOT NULL,
 CONSTRAINT [PK_SLCEmailDetails] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCEvent]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCEvent](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[EventType] [int] NOT NULL,
	[EventSubType] [int] NULL,
	[IsRunning] [bit] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[StationId] [varchar](50) NOT NULL,
	[SiteId] [varchar](50) NOT NULL,
	[IsFormula] [bit] NOT NULL,
	[FormulaName] [varchar](200) NULL,
 CONSTRAINT [PK_ShipLinkEvent] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCEventDocument]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCEventDocument](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SLCEvent_Id] [bigint] NOT NULL,
	[SLCDocument_Id] [bigint] NULL,
	[SLCShipmentInformation_Id] [bigint] NULL,
	[IsQualified] [bit] NOT NULL,
 CONSTRAINT [PK_ShipLinkEventQualifiedDocument] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCOutput]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCOutput](
	[Id] [bigint] NOT NULL,
	[SLCEventDocument_Id] [bigint] NULL,
	[DocumentOutput] [varchar](50) NOT NULL,
	[OutputType] [varchar](50) NOT NULL,
	[FilePath] [varchar](50) NULL,
	[EmailTemplate] [varchar](50) NULL,
	[FileName] [varchar](50) NULL,
	[TargetFolder] [varchar](50) NULL,
	[NoOfCopies] [int] NULL,
	[TargetPrinter] [varchar](50) NULL,
	[OrderMethod] [varchar](50) NULL,
	[ErrorCode] [varchar](50) NULL,
	[ErrorMessage] [varchar](4000) NULL,
	[FormulaName] [varchar](50) NULL,
	[ParentOrderId] [varchar](50) NULL,
 CONSTRAINT [PK_SLCOutput] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCSetting]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCSetting](
	[FieldName] [varchar](50) NOT NULL,
	[FieldValue] [varchar](500) NOT NULL,
	[FieldValue1] [varchar](500) NULL,
 CONSTRAINT [PK_SLCSetting] PRIMARY KEY CLUSTERED 
(
	[FieldName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCShipmentByOrder]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCShipmentByOrder](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[SalesOrder] [varchar](50) NOT NULL,
	[OrderId] [varchar](50) NOT NULL,
	[ParentOrderId] [varchar](50) NOT NULL,
	[ShipDate] [datetime] NULL,
	[OrderDate] [datetime] NULL,
	[ReqShipDate] [datetime] NULL,
	[CustomerNumber] [varchar](50) NULL,
	[PoNumber1] [varchar](50) NULL,
	[ShipViaDesc] [varchar](50) NULL,
	[ShipViaCode] [varchar](20) NULL,
	[Salesperson] [varchar](2000) NULL,
	[SpecialInstructions] [varchar](300) NULL,
	[InvoiceTerms] [varchar](50) NULL,
	[Warehouse] [varchar](50) NULL,
	[CustomerName] [varchar](100) NULL,
	[ShipAddress1] [varchar](500) NULL,
	[ShipAddress2] [varchar](500) NULL,
	[ShipAddress3] [varchar](500) NULL,
	[ShipAddress4] [varchar](500) NULL,
	[ShipAddress5] [varchar](500) NULL,
	[ShipCountry] [varchar](100) NULL,
	[ShipPostalCode] [varchar](9) NULL,
	[OrderGLCode] [varchar](20) NULL,
	[FreightPayTerms] [varchar](50) NULL,
	[OrderComment] [varchar](50) NULL,
	[Telephone1] [varchar](15) NULL,
	[Telephone2] [varchar](15) NULL,
	[IsTaxExempt] [bit] NULL,
	[TaxIdNumber] [varchar](15) NULL,
	[Custom1] [varchar](200) NULL,
	[Custom2] [varchar](200) NULL,
	[Custom3] [varchar](200) NULL,
	[Custom4] [varchar](200) NULL,
	[Custom5] [varchar](200) NULL,
	[Custom6] [varchar](200) NULL,
	[Custom7] [varchar](200) NULL,
	[Custom8] [varchar](200) NULL,
	[Custom9] [varchar](200) NULL,
	[Custom10] [varchar](200) NULL,
	[InvoiceNumber] [varchar](50) NULL,
	[PoNumber2] [varchar](50) NULL,
	[JobNumber] [varchar](50) NULL,
	[OrderStatus] [varchar](50) NULL,
	[OrderType] [varchar](20) NULL,
	[OrderMemo1] [varchar](50) NULL,
	[OrderMemo2] [varchar](50) NULL,
	[OrderMemo3] [varchar](50) NULL,
	[ReqDelDate] [datetime] NULL,
	[AltShipViaCode] [varchar](20) NULL,
	[OrderShipClass] [varchar](20) NULL,
	[OrderPackagingType] [varchar](20) NULL,
	[FreightPayAcct] [varchar](20) NULL,
	[AltFreightPayAcct] [varchar](20) NULL,
	[FreightChargeTerms] [varchar](20) NULL,
	[FreightChargeType] [varchar](20) NULL,
	[FreightCostType] [varchar](20) NULL,
	[DeliveryTerms] [varchar](20) NULL,
	[SalespersonEmail] [varchar](2000) NULL,
	[Branch] [varchar](20) NULL,
	[Area] [varchar](20) NULL,
	[Region] [varchar](20) NULL,
	[IsCustomerOnHold] [bit] NOT NULL,
	[IsBackOrder] [bit] NOT NULL,
	[IsConsolidatedShipmentParent] [bit] NOT NULL,
	[IsConsolidatedShipmentChild] [bit] NOT NULL,
	[IsOrderSerialNumberReq] [bit] NOT NULL,
	[IsOrderLotNumberReq] [bit] NOT NULL,
	[IsAsnReq] [bit] NOT NULL,
	[IsResidential] [bit] NOT NULL,
	[IsTaxFreight] [bit] NOT NULL,
	[Operator] [varchar](50) NULL,
	[ShipCustomerName] [varchar](50) NULL,
	[ShipCity] [varchar](50) NULL,
	[ShipStateProv] [varchar](50) NULL,
	[ShipCountryName] [varchar](50) NULL,
	[ShipCountryCodeIso] [varchar](3) NULL,
	[SoldCustomerName] [varchar](50) NULL,
	[SoldAddress1] [varchar](500) NULL,
	[SoldAddress2] [varchar](500) NULL,
	[SoldAddress3] [varchar](500) NULL,
	[SoldCity] [varchar](50) NULL,
	[SoldStateProv] [varchar](50) NULL,
	[SoldPostalCode] [varchar](20) NULL,
	[SoldCountryName] [varchar](50) NULL,
	[SoldCountryCodeIso] [varchar](3) NULL,
	[TelephoneExt1] [varchar](6) NULL,
	[TelephoneExt2] [varchar](6) NULL,
	[Email1] [varchar](500) NULL,
	[Email2] [varchar](500) NULL,
	[Email3] [varchar](500) NULL,
	[Email4] [varchar](500) NULL,
	[Email5] [varchar](500) NULL,
	[TaxLoc1] [varchar](50) NULL,
	[TaxLoc2] [varchar](50) NULL,
	[TaxLoc3] [varchar](50) NULL,
	[ExchangeRateCode] [varchar](10) NULL,
	[ExchangeRatePct] [decimal](18, 3) NULL,
	[ExchangeRateMulDivFlag] [varchar](3) NULL,
	[BaseCurrency] [varchar](10) NULL,
	[OrderCurrency] [varchar](10) NULL,
	[ShipmentCurrency] [varchar](10) NULL,
	[OrdTotalGoodsCharge] [decimal](18, 3) NULL,
	[OrdTotalGoodsCost] [decimal](18, 3) NULL,
	[OrdTotalInvoiceCharge] [decimal](18, 3) NULL,
	[OrdAdjTotalGoodsCharge] [decimal](18, 3) NULL,
	[OrdAdjTotalInvoiceCharge] [decimal](18, 3) NULL,
	[CreditAmt] [decimal](18, 3) NULL,
	[DebitAmt] [decimal](18, 3) NULL,
	[FixedFreightCharge] [decimal](18, 3) NULL,
	[FixedFreightSurcharge1] [decimal](18, 3) NULL,
	[FixedFreightSurcharge2] [decimal](18, 3) NULL,
	[PercentFreightSurcharge1] [decimal](18, 3) NULL,
	[PercentFreightSurcharge2] [decimal](18, 3) NULL,
	[SYS_DiscPct1] [decimal](18, 3) NULL,
	[SYS_DiscPct2] [decimal](18, 3) NULL,
	[SYS_DiscPct3] [decimal](18, 3) NULL,
	[SYS_AltShipAddrFlag] [varchar](1) NULL,
	[SYS_EntInvoice] [varchar](20) NULL,
	[SYS_DeliveryNote] [varchar](50) NULL,
	[SYS_AlternateKey] [varchar](10) NULL,
	[SYS_GstExemptFlag] [varchar](1) NULL,
	[SYS_GstExemptORide] [varchar](1) NULL,
	[SYS_GstExemptNum] [varchar](15) NULL,
	[SYS_CounterSalesFlag] [varchar](1) NULL,
	[SYS_MultiShipCode] [varchar](5) NULL,
	[SYS_WebCreated] [varchar](1) NULL,
	[SYS_State] [varchar](2) NULL,
	[SYS_CountyZip] [varchar](5) NULL,
	[SYS_ExtendedTaxCode] [varchar](3) NULL,
	[SYS_IsEdiShippingSystemOrder] [bit] NOT NULL,
	[ErpFreightCharge] [decimal](18, 3) NULL,
	[ErpFreightCost] [decimal](18, 3) NULL,
	[CurrencyCode] [varchar](50) NULL,
	[OrderedValue] [decimal](18, 3) NULL,
	[OrderWeight] [decimal](18, 3) NULL,
	[OrdGLCode] [varchar](50) NULL,
 CONSTRAINT [PK_SLCShipmentByOrders] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCShipmentDetail]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCShipmentDetail](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SLCShipmentByOrder_Id] [bigint] NOT NULL,
	[OrderId] [varchar](50) NOT NULL,
	[ParentOrderId] [varchar](50) NULL,
	[ShipDate] [datetime] NULL,
	[LineNumber] [decimal](4, 0) NOT NULL,
	[LineType] [varchar](1) NULL,
	[PartNumber] [varchar](50) NULL,
	[CusPartNumber] [varchar](50) NULL,
	[PartDesc] [varchar](50) NULL,
	[SKU] [varchar](50) NULL,
	[Warehouse] [varchar](50) NULL,
	[OrderQty] [decimal](18, 3) NULL,
	[ShipQty] [decimal](18, 3) NULL,
	[BackOrderQty] [decimal](18, 3) NULL,
	[ItemPrice] [decimal](18, 3) NULL,
	[ItemDiscPrice] [decimal](18, 3) NULL,
	[ItemCost] [decimal](18, 3) NULL,
	[ItemUom] [varchar](3) NULL,
	[ItemShipClass] [varchar](50) NULL,
	[ItemWeight] [decimal](18, 3) NULL,
	[ItemVolume] [decimal](18, 3) NULL,
	[TotalLineCharge] [decimal](18, 3) NULL,
	[TariffCode] [varchar](25) NULL,
	[TaxCode] [varchar](50) NULL,
	[TotalLineCost] [decimal](18, 3) NULL,
	[CountryOfOrigin] [varchar](50) NULL,
	[NMFC] [varchar](50) NULL,
	[FreightClass] [varchar](50) NULL,
	[IsSerialNumberReq] [bit] NULL,
	[BOMFlag] [varchar](1) NULL,
	[ProductClass] [varchar](50) NULL,
	[IsTaxable] [bit] NULL,
	[Custom1] [varchar](200) NULL,
	[Custom2] [varchar](200) NULL,
	[Custom3] [varchar](200) NULL,
	[Custom4] [varchar](200) NULL,
	[Custom5] [varchar](200) NULL,
	[Custom6] [varchar](200) NULL,
	[Custom7] [varchar](200) NULL,
	[Custom8] [varchar](200) NULL,
	[Custom9] [varchar](200) NULL,
	[Custom10] [varchar](200) NULL,
	[AltPrice] [varchar](50) NULL,
	[Bin] [varchar](50) NULL,
	[CaseCode] [varchar](50) NULL,
	[CaseHeight] [decimal](18, 3) NULL,
	[CaseLength] [decimal](18, 3) NULL,
	[CaseWeight] [decimal](18, 3) NULL,
	[CaseWidth] [decimal](18, 3) NULL,
	[Ecc1] [varchar](50) NULL,
	[Ecc2] [varchar](50) NULL,
	[Ecc3] [varchar](50) NULL,
	[Ecc4] [varchar](50) NULL,
	[Ecc5] [varchar](50) NULL,
	[FreightCharge] [varchar](50) NULL,
	[HazardousCode] [varchar](50) NULL,
	[HazardousType] [varchar](50) NULL,
	[HazardousUom] [varchar](50) NULL,
	[HazmatCustom1] [varchar](50) NULL,
	[HazmatCustom2] [varchar](50) NULL,
	[Height] [decimal](18, 3) NULL,
	[InitLineNumber] [varchar](50) NULL,
	[IsCase] [bit] NOT NULL,
	[IsFreightCharge] [bit] NOT NULL,
	[IsHazardous] [bit] NOT NULL,
	[IsItemLotNoReq] [bit] NOT NULL,
	[IsItemSerialNoReq] [bit] NOT NULL,
	[IsKit] [bit] NOT NULL,
	[IsMiscCharge] [bit] NOT NULL,
	[IsServiceCharge] [bit] NOT NULL,
	[ItemCustom1] [varchar](50) NULL,
	[ItemCustom2] [varchar](50) NULL,
	[ItemCustom3] [varchar](50) NULL,
	[ItemCustom4] [varchar](50) NULL,
	[ItemCustom5] [varchar](50) NULL,
	[ItemDiscPrice1] [decimal](18, 3) NULL,
	[ItemPackagingType] [varchar](50) NULL,
	[ItemPrice1] [decimal](18, 3) NULL,
	[ItemPriceCode] [varchar](50) NULL,
	[ItemShipClass1] [decimal](18, 3) NULL,
	[KitType] [varchar](50) NULL,
	[Length] [decimal](18, 3) NULL,
	[ManuCountryCode] [varchar](50) NULL,
	[Nafta1] [varchar](50) NULL,
	[Nafta2] [varchar](50) NULL,
	[Nafta3] [varchar](50) NULL,
	[Nafta4] [varchar](50) NULL,
	[Nafta5] [varchar](50) NULL,
	[SpecialHandlingFlag] [varchar](50) NULL,
	[SYS_MConvFactOrdUm] [varchar](50) NULL,
	[SYS_MDiscValFlag] [varchar](50) NULL,
	[SYS_MDiscValue] [varchar](50) NULL,
	[SYS_MFstTaxCode] [varchar](50) NULL,
	[SYS_MItemDisc1] [varchar](50) NULL,
	[SYS_MItemDisc2] [varchar](50) NULL,
	[SYS_MItemDisc3] [varchar](50) NULL,
	[SYS_MMulDivPrcFct] [varchar](50) NULL,
	[SYS_MPriceUom] [varchar](50) NULL,
	[SYS_NComment] [varchar](500) NULL,
	[SYS_NCommentFromLin] [varchar](50) NULL,
	[SYS_NCommentTextTyp] [varchar](50) NULL,
	[SYS_NCommentType] [varchar](50) NULL,
	[TraceableFlag] [varchar](50) NULL,
	[UpcCode] [varchar](50) NULL,
	[Width] [decimal](18, 3) NULL,
	[IsHazMat] [bit] NOT NULL,
	[IsHazMatOrmd] [bit] NOT NULL,
	[HazMatCode] [varchar](50) NULL,
	[HazMatDesc] [varchar](50) NULL,
	[HazMatUom] [varchar](50) NULL,
	[HazMatQty] [decimal](18, 3) NULL,
	[AltDesc] [varchar](200) NULL,
	[IsCommodity] [bit] NOT NULL,
 CONSTRAINT [PK_SLCShipmentDetails] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCShipmentInformation]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCShipmentInformation](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[ParentOrderId] [varchar](50) NULL,
	[ShipDate] [datetime] NULL,
	[CarrierName] [varchar](200) NULL,
	[CarrierServiceName] [varchar](200) NULL,
	[MasterTrackingNumber] [varchar](30) NULL,
	[ProNumber] [varchar](30) NULL,
	[BolNumber] [varchar](30) NULL,
	[RecordStatus] [varchar](1) NULL,
	[IsVoidIndicator] [bit] NOT NULL,
	[NumberOfParcels] [int] NULL,
	[Weight] [decimal](18, 3) NULL,
	[Warehouse] [varchar](50) NULL,
	[StationId] [varchar](20) NOT NULL,
	[ShipRequest_Id] [bigint] NOT NULL,
	[Email1] [varchar](500) NULL,
	[Email2] [varchar](500) NULL,
	[Email3] [varchar](500) NULL,
	[Email4] [varchar](500) NULL,
	[Email5] [varchar](500) NULL,
	[Custom1] [varchar](500) NULL,
	[Custom2] [varchar](500) NULL,
	[Custom3] [varchar](500) NULL,
	[Custom4] [varchar](500) NULL,
	[Custom5] [varchar](500) NULL,
	[Custom6] [varchar](500) NULL,
	[Custom7] [varchar](500) NULL,
	[Custom8] [varchar](500) NULL,
	[Custom9] [varchar](500) NULL,
	[Custom10] [varchar](500) NULL,
	[HtmlContent1] [varchar](4000) NULL,
	[HtmlContent2] [varchar](4000) NULL,
	[HtmlContent3] [varchar](4000) NULL,
	[HtmlContent4] [varchar](4000) NULL,
	[HtmlContent5] [varchar](4000) NULL,
	[HtmlContent6] [varchar](4000) NULL,
	[HtmlContent7] [varchar](4000) NULL,
	[HtmlContent8] [varchar](4000) NULL,
	[HtmlContent9] [varchar](4000) NULL,
	[HtmlContent10] [varchar](4000) NULL,
	[ShipmentAndHandlingPublishedCharge] [decimal](18, 3) NULL,
	[ShipmentAndHandlingNegotiatedCharge] [decimal](18, 3) NULL,
	[ShipmentPublishedCharge] [decimal](18, 3) NULL,
	[ShipmentNegotiatedCharge] [decimal](18, 3) NULL,
	[ErpFreightCharge] [decimal](18, 3) NULL,
	[ErpFreightCost] [decimal](18, 3) NULL,
	[IsFreeFreight] [bit] NOT NULL,
	[CarrierShipmentWeightUom] [varchar](50) NULL,
	[ShipmentWeightUom] [varchar](50) NULL,
	[ShipRoundedWeight] [int] NULL,
	[ShipActualWeight] [decimal](18, 3) NULL,
	[ShipDimWeight] [decimal](18, 3) NULL,
	[IsMultiOrder] [bit] NOT NULL,
	[MultiOrderId] [varchar](1000) NULL,
	[MultiPoNumber1] [varchar](1000) NULL,
	[MultiPoNumber2] [varchar](1000) NULL,
	[ParentPoNumber1] [varchar](50) NULL,
	[ParentPoNumber2] [varchar](50) NULL,
	[ParentCustomerNumber] [varchar](50) NULL,
	[ShipmentCurrency] [varchar](3) NULL,
	[ShipTotalGoodsCharge] [decimal](18, 3) NULL,
	[ShipTotalGoodsCost] [decimal](18, 3) NULL,
	[ShipTotalInvoiceCharge] [decimal](18, 3) NULL,
	[ShipAdjTotalGoodsCharge] [decimal](18, 3) NULL,
	[ShipAdjTotalInvoiceCharge] [decimal](18, 3) NULL,
	[ShipperAccount] [varchar](20) NULL,
	[ShipperProfile] [varchar](50) NULL,
	[FreightPayTerms] [varchar](50) NULL,
	[CarrierFreightPayTerms] [varchar](50) NULL,
	[FreightPayAccount] [varchar](20) NULL,
	[FreightPayOption] [varchar](20) NULL,
	[BillDutyTaxTo] [varchar](20) NULL,
	[CarrierBillDutyTaxTo] [varchar](1) NULL,
	[IsSplitDutyTaxTo] [bit] NOT NULL,
	[IsHandlingCharge] [bit] NOT NULL,
	[HandlingChargeType] [varchar](20) NULL,
	[HandlingChargeFlatRate] [decimal](18, 3) NULL,
	[HandlingChargePercentage] [decimal](18, 3) NULL,
	[IsCarrierDv] [bit] NOT NULL,
	[DvAmount] [decimal](18, 3) NULL,
	[DvAmountOrdCurr] [decimal](18, 3) NULL,
	[InsuredValueCharge] [decimal](18, 3) NULL,
	[IsShipperPayDv] [bit] NOT NULL,
	[IsAltDv] [bit] NOT NULL,
	[AltDvAmount] [decimal](18, 3) NULL,
	[AltDvCharge] [decimal](18, 3) NULL,
	[IsReturnService] [bit] NOT NULL,
	[ReturnServiceType] [varchar](50) NULL,
	[ReturnServiceMerchDesc] [varchar](50) NULL,
	[IsSaturdayDel] [bit] NOT NULL,
	[IsSaturdayPickup] [bit] NOT NULL,
	[IsSundayDel] [bit] NOT NULL,
	[IsSundayPickup] [bit] NOT NULL,
	[DelConfirmationOption] [varchar](40) NULL,
	[IsDelConfirmSig] [bit] NOT NULL,
	[IsDelConfirmNoSig] [bit] NOT NULL,
	[IsDelConfirmAdultSig] [bit] NOT NULL,
	[IsDelConfirmDirectSig] [bit] NOT NULL,
	[IsDelConfirmIndirectSig] [bit] NOT NULL,
	[IsCOD] [bit] NOT NULL,
	[CODType] [varchar](6) NULL,
	[CODAmount] [decimal](18, 3) NULL,
	[CODAmountOrdCurr] [decimal](18, 3) NULL,
	[CODCurrencyCode] [varchar](50) NULL,
	[IsCheckMoneyOrder] [bit] NOT NULL,
	[IsAddShippingCharges] [bit] NOT NULL,
	[IsElecCOD] [bit] NOT NULL,
	[IsDocumentsOnly] [bit] NOT NULL,
	[IsResidential] [bit] NOT NULL,
	[Reference1] [varchar](255) NULL,
	[Reference2] [varchar](255) NULL,
	[Reference3] [varchar](255) NULL,
	[Reference4] [varchar](255) NULL,
	[Reference5] [varchar](255) NULL,
	[ItemDescription] [varchar](500) NULL,
	[DescOfGoods] [varchar](500) NULL,
	[SpecialInstructionsForShipment] [varchar](500) NULL,
	[SpecialInstructionsForDelivery] [varchar](500) NULL,
	[MerchandiseDes] [varchar](500) NULL,
	[AdditionalDocuments] [varchar](500) NULL,
	[MerchandiseDescForPar] [varchar](500) NULL,
	[ThirdPartyCompany] [varchar](500) NULL,
	[ThirdPartyAddress1] [varchar](500) NULL,
	[ThirdPartyAddress2] [varchar](500) NULL,
	[ThirdPartyCity] [varchar](500) NULL,
	[ThirdPartyState] [varchar](500) NULL,
	[ThirdPartyPostalCode] [varchar](500) NULL,
	[ThirdPartyCountry] [varchar](500) NULL,
	[ThirdPartyPhone] [varchar](100) NULL,
	[ThirdPartyFax] [varchar](100) NULL,
	[IsFreight] [bit] NOT NULL,
	[IsLTL] [bit] NOT NULL,
	[LoadId] [varchar](50) NULL,
	[LTLPieceQuantity] [int] NULL,
	[LTLStatus] [varchar](50) NULL,
	[PalletQty] [int] NULL,
	[PieceQty] [int] NULL,
	[TruckId] [varchar](50) NULL,
	[SCAC] [varchar](50) NULL,
	[IsAutoPickAndShip] [bit] NOT NULL,
	[IsShipLinkConsolidation] [bit] NOT NULL,
	[CurrencyCode] [varchar](50) NULL,
	[OrdCurrency] [varchar](50) NULL,
	[CarrCurrency] [varchar](50) NULL,
	[BaseCurrency] [varchar](5) NULL,
	[CarrierRatingCurrency] [varchar](5) NULL,
	[GoodsExchRate] [decimal](18, 3) NULL,
	[ChargesExchRate] [decimal](18, 3) NULL,
	[GLCode] [varchar](50) NULL,
	[IsCrossBorderConsolidation] [bit] NOT NULL,
	[DestinationCountry] [varchar](100) NULL,
	[EmailLabelTo] [varchar](500) NULL,
	[EmailReturnMessage] [varchar](500) NULL,
	[ExpirationDate] [varchar](50) NULL,
	[AceNumber] [varchar](50) NULL,
	[PackListNotes] [varchar](500) NULL,
	[PackListNotes2] [varchar](500) NULL,
	[PackListPrint] [bit] NOT NULL,
	[PackListSubject] [varchar](100) NULL,
	[ServiceCode] [varchar](50) NULL,
	[ServiceType] [varchar](50) NULL,
	[PackagingType] [varchar](50) NULL,
	[IsSMSNotify] [bit] NOT NULL,
	[SMSNumber] [varchar](50) NULL,
	[SMSMsgText] [varchar](500) NULL,
	[SMSMsgStatus] [varchar](50) NULL,
	[TrackingNumber] [varchar](30) NULL,
	[TrackingUrl] [varchar](500) NULL,
	[PODUrl] [varchar](500) NULL,
	[BOLUrl] [varchar](500) NULL,
	[TrkOrgEstDeliveryDate] [datetime] NULL,
	[ExpTranTime] [int] NULL,
	[TrkQueryDate] [datetime] NULL,
	[TrkStatus] [varchar](500) NULL,
	[TrkCarrierStatus] [varchar](500) NULL,
	[TrkCurrentLocation] [varchar](500) NULL,
	[TrkSchedDelDate] [datetime] NULL,
	[TrkDeliveryDate] [datetime] NULL,
	[TrkCarrierActivity] [varchar](500) NULL,
	[TrkIsRecipientSigned] [bit] NOT NULL,
	[TrkRecipientSignature] [image] NULL,
	[TrkLatitude] [varchar](50) NULL,
	[TrkLongitude] [varchar](50) NULL,
	[EDILabelType] [varchar](50) NULL,
	[TrkIsTrackPeriodExpired] [bit] NOT NULL,
	[TrkPickupDate] [datetime] NULL,
	[ShipmentType] [varchar](10) NULL,
	[SiteId] [int] NOT NULL,
	[TrkUpdEstDeliveryDate] [datetime] NULL,
 CONSTRAINT [PK_SLCShipmentInformations] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCShipmentPackage]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCShipmentPackage](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[UCCId] [varchar](20) NOT NULL,
	[ShipmentId] [varchar](6) NULL,
	[PackageId] [int] NULL,
	[TrackingNumber] [varchar](500) NULL,
	[SecondaryTrackingNumber] [varchar](500) NULL,
	[InsuredValue] [decimal](18, 3) NULL,
	[Weight] [decimal](18, 3) NULL,
	[Length] [decimal](18, 3) NULL,
	[Width] [decimal](18, 3) NULL,
	[Height] [decimal](18, 3) NULL,
	[CaseNumber] [varchar](8) NULL,
	[CaseSeqNumber] [int] NULL,
	[Custom1] [varchar](200) NULL,
	[Custom2] [varchar](200) NULL,
	[Custom3] [varchar](200) NULL,
	[Custom4] [varchar](200) NULL,
	[Custom5] [varchar](200) NULL,
	[IsCarrierDV] [bit] NOT NULL,
	[IsAltDV] [bit] NOT NULL,
	[DvAmount] [decimal](18, 3) NULL,
	[DvAmountOrdCurr] [decimal](18, 3) NULL,
	[IsShipperPayDv] [bit] NOT NULL,
	[AltDvAmount] [decimal](18, 3) NULL,
	[AltDvCharge] [decimal](18, 3) NULL,
	[PiecesOnPallet] [int] NULL,
	[ParActualWeight] [decimal](18, 3) NULL,
	[ParRoundedWeight] [decimal](18, 3) NULL,
	[ParDimWeight] [decimal](18, 3) NULL,
	[Reference1] [varchar](50) NULL,
	[Reference2] [varchar](500) NULL,
	[Reference3] [varchar](50) NULL,
	[Reference4] [varchar](50) NULL,
	[Reference5] [varchar](50) NULL,
	[IsCod] [bit] NOT NULL,
	[CodType] [varchar](6) NULL,
	[CodAmount] [decimal](18, 3) NULL,
	[CODAmountOrdCurr] [decimal](18, 3) NULL,
	[CodCurrencyCode] [varchar](50) NULL,
	[IsCheckMoneyOrder] [bit] NOT NULL,
	[IsAddShippingCharges] [bit] NOT NULL,
	[ParRefCharge] [decimal](18, 3) NULL,
	[ParPublishedCharge] [decimal](18, 3) NULL,
	[UspsWeight] [decimal](18, 3) NULL,
	[ParNegRatesCharge] [decimal](18, 3) NULL,
	[IsUspsDelConfirmation] [bit] NOT NULL,
	[UspsDelConfirmationType] [varchar](50) NULL,
	[ParType] [varchar](50) NULL,
	[PostalServiceTrackingID] [varchar](50) NULL,
	[GroundNMFC] [varchar](50) NULL,
	[GroundSub] [varchar](50) NULL,
	[GroundFreightClass] [varchar](50) NULL,
	[ParTotalGoodsCharge] [decimal](18, 3) NULL,
	[ParTotalGoodsCost] [decimal](18, 3) NULL,
	[ParTotalInvoiceCharge] [decimal](18, 3) NULL,
	[ParAdjTotalGoodsCharge] [decimal](18, 3) NULL,
	[ParAdjTotalInvoiceCharge] [decimal](18, 3) NULL,
	[BOL] [varchar](30) NULL,
	[IsAutoPickAndShip] [bit] NOT NULL,
	[IsShipperRelease] [bit] NOT NULL,
	[IsAddHandlingCharges] [bit] NOT NULL,
	[ERPPackageId] [varchar](50) NULL,
	[ERPShipmentId] [varchar](20) NULL,
 CONSTRAINT [PK_SLCShipmentPackage] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLCShipmentPackageContent]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLCShipmentPackageContent](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[SLCShipmentPackage_Id] [int] NOT NULL,
	[SLCShipmentDetail_Id] [bigint] NOT NULL,
	[ShipQty] [decimal](18, 3) NULL,
	[PartNumber] [varchar](50) NULL,
	[LineNumber] [decimal](4, 0) NULL,
	[OrderId] [varchar](50) NULL,
 CONSTRAINT [PK_SLCShipmentPackageContent] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLInternationalDocumentation]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLInternationalDocumentation](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[IsRequestDutiesTaxes] [bit] NOT NULL,
	[IsCreateAnInvoice] [bit] NOT NULL,
	[InvTermsOfSale] [varchar](50) NULL,
	[InvReasonForExport] [varchar](50) NULL,
	[InvReasonForExportStr] [varchar](50) NULL,
	[InvDeclStatement] [varchar](50) NULL,
	[InvAdditionalComments] [varchar](500) NULL,
	[InvCN22CurrCode] [varchar](50) NULL,
	[InvoiceDiscount] [float] NULL,
	[InvChargesFreight] [float] NULL,
	[InvChargesInsurance] [float] NULL,
	[InvoiceChargesOther] [float] NULL,
	[InvoiceLineTotal] [float] NULL,
	[IsInvImporterSameAsShipTo] [bit] NOT NULL,
	[IsInvImporterSameAsShipToStr] [varchar](50) NULL,
	[CustomsValueTotal] [float] NULL,
	[CustomsValCurrCode] [varchar](50) NULL,
	[CustomsValOrigin] [varchar](50) NULL,
	[EEIFilingMethod] [varchar](50) NULL,
	[EEIAESExemptLgnd] [varchar](50) NULL,
	[EEIPartiesTransaction] [varchar](50) NULL,
	[EEIConsigneeSameAsShipTo] [varchar](50) NULL,
	[EEIConsigneeType] [varchar](50) NULL,
	[EEIShipmentRefNo] [varchar](50) NULL,
	[EEIInternalTransactionNo] [varchar](50) NULL,
	[EEIRoutedTransaction] [varchar](50) NULL,
	[EEICurrencyConversion] [varchar](50) NULL,
	[IsEEINotification] [bit] NOT NULL,
	[EEINotifEmail] [varchar](50) NULL,
	[EEIInbondCode] [varchar](50) NULL,
	[EEIInbondNumber] [varchar](50) NULL,
	[EEIInbondFTZIdentifier] [varchar](50) NULL,
	[COUPSPrepareCO] [varchar](50) NULL,
	[COOwnerOrAgent] [varchar](50) NULL,
	[NAFTAProducer] [varchar](50) NULL,
	[NAFTABlanketPeriodStart] [varchar](50) NULL,
	[NAFTABlanketPeriodEnd] [varchar](50) NULL,
	[MovementReferenceNo] [varchar](50) NULL,
	[CN22GoodsType] [varchar](50) NULL,
	[CN22GoodsTypeDesc] [varchar](50) NULL,
	[CN22Number] [varchar](50) NULL,
	[DutiesCost] [float] NULL,
	[VATCost] [float] NULL,
	[TaxesAndFeesCost] [float] NULL,
	[TotalDutiesAndTaxes] [float] NULL,
	[IsNAFTA] [bit] NOT NULL,
	[NotifyBrokerNameNum] [varchar](500) NULL,
	[NotifyBrokerEmail] [varchar](500) NULL,
	[NotifyBrokerAddress] [varchar](500) NULL,
	[NotifyBrokerCity] [varchar](500) NULL,
	[NotifyBrokerState] [varchar](500) NULL,
	[NotifyBrokerPostalCode] [varchar](20) NULL,
	[NotifyBrokerCountry] [varchar](200) NULL,
	[DescOfGoods] [varchar](50) NULL,
	[NotifyBrokerName] [varchar](500) NULL,
	[NotifyBrokerPhone] [varchar](500) NULL,
	[NotifyBrokerContact] [varchar](500) NULL,
 CONSTRAINT [PK_SLInternationalDocumentation] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLInternationalGood]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLInternationalGood](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[OrderId] [varchar](50) NULL,
	[InitLineNumber] [varchar](50) NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[PartNumber] [varchar](50) NULL,
	[DescOfGood] [varchar](250) NULL,
	[InvNAFTACN22TariffCode] [varchar](50) NULL,
	[InvNAFTACOCN22CountryOrigin] [varchar](50) NULL,
	[InvoiceCN22Units] [varchar](50) NULL,
	[InvoiceCN22UOM] [varchar](50) NULL,
	[InvoiceEEICN22UnitPrice] [float] NULL,
	[InvoiceEEICN22CurrencyCode] [varchar](50) NULL,
	[InvoiceNetWeight] [float] NULL,
	[EEICOGrossWeight] [float] NULL,
	[EEICOLBSorKgs] [varchar](50) NULL,
	[EEIPrintGoodOnEEI] [varchar](50) NULL,
	[InvoiceEEICOMarksNumbers] [varchar](50) NULL,
	[EEIScheduleBNumber] [varchar](50) NULL,
	[EEIScheduleBUnits1] [varchar](50) NULL,
	[EEIScheduleBUnits2] [varchar](50) NULL,
	[EEIUnitofMeasure1] [varchar](50) NULL,
	[EEIUnitofMeasure2] [varchar](50) NULL,
	[EEIECCN] [varchar](50) NULL,
	[EEILicenseType] [varchar](50) NULL,
	[EEILicenseNumber] [varchar](50) NULL,
	[EEILicenseExpirationDate] [datetime] NULL,
	[EEILicenseLineValue] [varchar](50) NULL,
	[EEIExportInfoCode] [varchar](50) NULL,
	[DDTCACMNumber] [varchar](50) NULL,
	[DDTCITARExemptionCode] [varchar](50) NULL,
	[DDTCRegistrationNumber] [varchar](50) NULL,
	[IsDDTCMilitaryEquipment] [bit] NOT NULL,
	[IsDDTCEligiblePartyCertif] [bit] NOT NULL,
	[IsDDTCEligiblePartyCertifStr] [varchar](50) NULL,
	[DDTCUSMLCategoryCode] [varchar](50) NULL,
	[DDTCQuantity] [float] NULL,
	[DDTCUOM] [varchar](10) NULL,
	[DDTCLicenseLineNumber] [varchar](50) NULL,
	[IsNAFTAPrintGoodOnNAFTA] [bit] NOT NULL,
	[NAFTAPreferenceCriterion] [varchar](50) NULL,
	[NAFTAProducer] [varchar](50) NULL,
	[NAFTAMultipleCountriesOfOrigin] [varchar](50) NULL,
	[NAFTANetCostMethod] [varchar](50) NULL,
	[NAFTANetCostPeriodStartDate] [varchar](50) NULL,
	[NAFTANetCostPeriodEndDate] [varchar](50) NULL,
	[COPrintGoodOnCO] [varchar](50) NULL,
	[CONoOfPackagesContainingGood] [varchar](50) NULL,
	[IsSLIPrintGoodonSLI] [bit] NOT NULL,
	[DFM] [varchar](50) NULL,
	[IsCreateAnInvoiceStr] [varchar](50) NULL,
	[IsRequestDutiesTaxesStr] [varchar](50) NULL,
	[IsInvImporterSameAsShipToStr] [varchar](50) NULL,
	[InvoiceEEICN22UnitPriceOrdCurr] [float] NULL,
	[UserField1] [varchar](50) NULL,
 CONSTRAINT [PK_SLInternationalGood] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLParcel]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLParcel](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[IsCarrierDV] [bit] NOT NULL,
	[IsCarrierDVStr] [nvarchar](50) NULL,
	[IsAltDV] [bit] NOT NULL,
	[IsAltDVStr] [nvarchar](50) NULL,
	[DvAmount] [float] NULL,
	[DvAmountOrdCurr] [float] NULL,
	[IsShipperPayDv] [bit] NOT NULL,
	[IsShipperPayDvStr] [varchar](50) NULL,
	[AltDvAmount] [float] NULL,
	[AltDvCharge] [float] NULL,
	[Height] [float] NULL,
	[Width] [float] NULL,
	[Length] [float] NULL,
	[PiecesOnPallet] [int] NULL,
	[ParActualWeight] [float] NULL,
	[ParRoundedWeight] [float] NULL,
	[ParDimWeight] [float] NULL,
	[Reference1] [varchar](50) NULL,
	[Reference2] [varchar](500) NULL,
	[Reference3] [varchar](50) NULL,
	[Reference4] [varchar](50) NULL,
	[Reference5] [varchar](50) NULL,
	[IsCod] [bit] NOT NULL,
	[IsCodStr] [varchar](50) NULL,
	[CodType] [varchar](6) NULL,
	[CodAmount] [float] NULL,
	[CODAmountOrdCurr] [float] NULL,
	[CodCurrencyCode] [varchar](10) NULL,
	[IsCheckMoneyOrder] [bit] NOT NULL,
	[IsCheckMoneyOrderStr] [varchar](50) NULL,
	[IsAddShippingCharges] [bit] NOT NULL,
	[IsAddShippingChargesStr] [varchar](50) NULL,
	[IsVoid] [bit] NOT NULL,
	[IsVoidStr] [varchar](50) NULL,
	[ParRefCharge] [float] NULL,
	[ParPublishedCharge] [float] NULL,
	[UspsWeight] [float] NULL,
	[ParNegRatesCharge] [float] NULL,
	[IsUspsDelConfirmation] [bit] NOT NULL,
	[IsUspsDelConfirmationStr] [varchar](50) NULL,
	[UspsDelConfirmationType] [varchar](50) NULL,
	[ParType] [varchar](50) NULL,
	[PostalServiceTrackingID] [varchar](50) NULL,
	[GroundNMFC] [varchar](50) NULL,
	[GroundSub] [varchar](50) NULL,
	[GroundFreightClass] [varchar](50) NULL,
	[ParTotalGoodsCharge] [float] NULL,
	[ParTotalGoodsCost] [float] NULL,
	[ParTotalInvoiceCharge] [float] NULL,
	[ParAdjTotalGoodsCharge] [float] NULL,
	[ParAdjTotalInvoiceCharge] [float] NULL,
	[IsDelConfirmSig] [bit] NOT NULL,
	[IsDelConfirmSigStr] [varchar](50) NULL,
	[IsDelConfirmNoSig] [bit] NOT NULL,
	[IsDelConfirmNoSigStr] [varchar](50) NULL,
	[IsDelConfirmAdultSig] [bit] NOT NULL,
	[IsDelConfirmAdultSigStr] [varchar](50) NULL,
	[IsDelConfirmDirectSig] [bit] NOT NULL,
	[IsDelConfirmDirectSigStr] [varchar](50) NULL,
	[IsDelConfirmIndirectSig] [bit] NOT NULL,
	[IsDelConfirmIndirectSigStr] [varchar](50) NULL,
	[BOL] [nvarchar](500) NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[State] [nvarchar](100) NULL,
	[IsAutoPickAndShip] [bit] NOT NULL,
	[IsShipperRelease] [bit] NOT NULL,
	[IsShipperReleaseStr] [varchar](50) NULL,
	[IsAddHandlingCharges] [bit] NOT NULL,
	[IsAddHandlingChargesStr] [varchar](50) NULL,
	[ERPPackageId] [varchar](50) NULL,
	[ERPShipmentId] [varchar](20) NULL,
 CONSTRAINT [PK__SLParcel__3214EC07AD96366C] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLShipFrom]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLShipFrom](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[CustomerNumber] [varchar](500) NULL,
	[Company] [varchar](200) NULL,
	[Address1] [varchar](500) NULL,
	[Address2] [varchar](500) NULL,
	[Address3] [varchar](500) NULL,
	[Address4] [varchar](500) NULL,
	[City] [varchar](500) NULL,
	[StateProvinceCounty] [varchar](500) NULL,
	[PostalCode] [varchar](20) NULL,
	[CountryName] [varchar](200) NULL,
	[CountryCodeIso] [varchar](3) NULL,
	[CountryCallingCode] [varchar](3) NULL,
	[Telephone] [varchar](50) NULL,
	[AirportCode] [varchar](15) NULL,
	[TaxIdNumber] [varchar](100) NULL,
	[Ext] [varchar](10) NULL,
	[Email] [varchar](500) NULL,
	[Attention] [varchar](100) NULL,
 CONSTRAINT [PK_SLShipFrom] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLShipmentLTLDetail]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLShipmentLTLDetail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[ShipRequest_Id] [int] NOT NULL,
	[OrderId] [varchar](50) NOT NULL,
	[InitLineNumber] [varchar](50) NULL,
	[PartNumber] [varchar](50) NULL,
	[ProductClass] [varchar](50) NULL,
	[PartDesc] [varchar](50) NULL,
	[OrderQty] [varchar](50) NULL,
	[ShipQty] [varchar](50) NULL,
	[ShipClass] [varchar](50) NULL,
	[ShipNMFC] [varchar](50) NULL,
	[IsHazardous] [bit] NOT NULL,
	[HazardousUOM] [varchar](50) NULL,
	[HazardousCode] [varchar](50) NULL,
	[HazardousType] [varchar](50) NULL,
	[IsORMD] [bit] NOT NULL,
	[HazmatCustom1] [varchar](50) NULL,
	[HazmatCustom2] [varchar](50) NULL,
	[ItemDiscPrice] [decimal](18, 2) NULL,
	[ItemUOM] [varchar](50) NULL,
	[ItemWeight] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SLShipTo]    Script Date: 12/31/2021 10:50:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SLShipTo](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SLCShipmentInformation_Id] [bigint] NOT NULL,
	[TrackingNumber] [nvarchar](500) NULL,
	[CustomerNumber] [varchar](50) NULL,
	[Company] [varchar](50) NULL,
	[Address1] [varchar](50) NULL,
	[Address2] [varchar](50) NULL,
	[Address3] [varchar](50) NULL,
	[Address4] [varchar](50) NULL,
	[City] [varchar](50) NULL,
	[StateProvinceCounty] [varchar](50) NULL,
	[PostalCode] [varchar](20) NULL,
	[CountryName] [varchar](50) NULL,
	[CountryCodeIso] [varchar](3) NULL,
	[CarrierCountryCode] [varchar](200) NULL,
	[CountryCalllingCode] [varchar](3) NULL,
	[Telephone] [varchar](15) NULL,
	[AirportCode] [varchar](15) NULL,
	[TaxIdNumber] [varchar](15) NULL,
	[IsPoBox] [bit] NOT NULL,
	[IsPOBoxStr] [varchar](50) NULL,
	[IsResidential] [bit] NOT NULL,
	[IsResidentialStr] [varchar](20) NULL,
	[Attention] [varchar](100) NULL,
	[AddressType] [varchar](200) NULL,
	[State] [nvarchar](100) NULL,
 CONSTRAINT [PK_SLShipTo] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SystemLog](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[LogType] [int] NULL,
	[StackTrace] [nvarchar](2000) NULL,
	[ErrorMessage] [nvarchar](500) NULL,
	[CallerMemberName] [nvarchar](50) NULL,
	[Area] [nvarchar](100) NULL,
	[CreatedDate] [datetime] NULL,
 CONSTRAINT [PK_SystemLog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TrackingAccount]    Script Date: 11/4/2022 10:22:43 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TrackingAccount](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Protocol] [varchar](10) NULL,
	[Server] [varchar](100) NULL,
	[Username] [varchar](100) NULL,
	[Password] [varchar](100) NULL,
	[Port] [varchar](50) NULL,
	[Folder] [varchar](100) NULL,
	[IsSecureConnection] [bit] NULL,
	[Carrier] [varchar](50) NULL,
	[AccessKey] [varchar](100) NULL,
 CONSTRAINT [PK_TrackingAccount] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EODSiteClose] ADD  DEFAULT ((0)) FOR [IsFormula]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsDeliver__457F2FDE]  DEFAULT ((0)) FOR [IsDeliveryNotify1]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsNotify__47677850]  DEFAULT ((0)) FOR [IsNotify]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsNotifyS__485B9C89]  DEFAULT ((0)) FOR [IsNotifyStr]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsShipNot__494FC0C2]  DEFAULT ((0)) FOR [IsShipNotify1]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsPackLis__4B380934]  DEFAULT ((0)) FOR [IsPackList1]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsExcepti__4C2C2D6D]  DEFAULT ((0)) FOR [IsExceptionNotify1]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsInTrans__4E1475DF]  DEFAULT ((0)) FOR [IsInTransitNotify1]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsShipNot__4FFCBE51]  DEFAULT ((0)) FOR [IsShipNotify2]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsPackLis__51E506C3]  DEFAULT ((0)) FOR [IsPackList2]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsDeliver__52D92AFC]  DEFAULT ((0)) FOR [IsDeliveryNotify2]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsExcepti__54C1736E]  DEFAULT ((0)) FOR [IsExceptionNotify2]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsInTrans__56A9BBE0]  DEFAULT ((0)) FOR [IsInTransitNotify2]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsShipNot__58920452]  DEFAULT ((0)) FOR [IsShipNotify3]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsPackLis__5A7A4CC4]  DEFAULT ((0)) FOR [IsPackList3]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsDeliver__5B6E70FD]  DEFAULT ((0)) FOR [IsDeliveryNotify3]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsExcepti__5D56B96F]  DEFAULT ((0)) FOR [IsExceptionNotify3]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsInTrans__5F3F01E1]  DEFAULT ((0)) FOR [IsInTransitNotify3]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsShipNot__61274A53]  DEFAULT ((0)) FOR [IsShipNotify4]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsPackLis__630F92C5]  DEFAULT ((0)) FOR [IsPackList4]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsDeliver__6403B6FE]  DEFAULT ((0)) FOR [IsDeliveryNotify4]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsExcepti__65EBFF70]  DEFAULT ((0)) FOR [IsExceptionNotify4]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsInTrans__67D447E2]  DEFAULT ((0)) FOR [IsInTransitNotify4]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsShipNot__69BC9054]  DEFAULT ((0)) FOR [IsShipNotify5]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsPackLis__6BA4D8C6]  DEFAULT ((0)) FOR [IsPackList5]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsDeliver__6C98FCFF]  DEFAULT ((0)) FOR [IsDeliveryNotify5]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsExcepti__6E814571]  DEFAULT ((0)) FOR [IsExceptionNotify5]
GO
ALTER TABLE [dbo].[SLASN] ADD  CONSTRAINT [DF__SLASN__IsInTrans__70698DE3]  DEFAULT ((0)) FOR [IsInTransitNotify5]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsCase]  DEFAULT ((0)) FOR [IsCase]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsFreightCharge]  DEFAULT ((0)) FOR [IsFreightCharge]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsHazardous]  DEFAULT ((0)) FOR [IsHazardous]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsItemLotNoReq]  DEFAULT ((0)) FOR [IsItemLotNoReq]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsItemSerialNoReq]  DEFAULT ((0)) FOR [IsItemSerialNoReq]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsKit]  DEFAULT ((0)) FOR [IsKit]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsMiscCharge]  DEFAULT ((0)) FOR [IsMiscCharge]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsServiceCharge]  DEFAULT ((0)) FOR [IsServiceCharge]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsHazMat]  DEFAULT ((0)) FOR [IsHazMat]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsHazMatOrmd]  DEFAULT ((0)) FOR [IsHazMatOrmd]
GO
ALTER TABLE [dbo].[SLCEmailDetail] ADD  CONSTRAINT [DF_SLCEmailDetail_IsCommodity]  DEFAULT ((1)) FOR [IsCommodity]
GO
ALTER TABLE [dbo].[SLCEvent] ADD  CONSTRAINT [DF_SLCEvent_IsRunning]  DEFAULT ((1)) FOR [IsRunning]
GO
ALTER TABLE [dbo].[SLCEvent] ADD  CONSTRAINT [DF_SLCEvent_IsFormula]  DEFAULT ((0)) FOR [IsFormula]
GO
ALTER TABLE [dbo].[SLCEventDocument] ADD  CONSTRAINT [DF_SLCEventDocument_IsQualified]  DEFAULT ((0)) FOR [IsQualified]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsCustomerOnHold]  DEFAULT ((0)) FOR [IsCustomerOnHold]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsBackOrder]  DEFAULT ((0)) FOR [IsBackOrder]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsConsolidatedShipmentParent]  DEFAULT ((0)) FOR [IsConsolidatedShipmentParent]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsConsolidatedShipmentChild]  DEFAULT ((0)) FOR [IsConsolidatedShipmentChild]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsOrderSerialNumberReq]  DEFAULT ((0)) FOR [IsOrderSerialNumberReq]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsOrderLotNumberReq]  DEFAULT ((0)) FOR [IsOrderLotNumberReq]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsAsnReq]  DEFAULT ((0)) FOR [IsAsnReq]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsResidential]  DEFAULT ((0)) FOR [IsResidential]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_IsTaxFreight]  DEFAULT ((0)) FOR [IsTaxFreight]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] ADD  CONSTRAINT [DF_SLCShipmentByOrder_SYS_IsEdiShippingSystemOrder]  DEFAULT ((0)) FOR [SYS_IsEdiShippingSystemOrder]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsCase]  DEFAULT ((0)) FOR [IsCase]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsFreightCharge]  DEFAULT ((0)) FOR [IsFreightCharge]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsHazardous]  DEFAULT ((0)) FOR [IsHazardous]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsItemLotNoReq]  DEFAULT ((0)) FOR [IsItemLotNoReq]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsItemSerialNoReq]  DEFAULT ((0)) FOR [IsItemSerialNoReq]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsKit]  DEFAULT ((0)) FOR [IsKit]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsMiscCharge]  DEFAULT ((0)) FOR [IsMiscCharge]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsServiceCharge]  DEFAULT ((0)) FOR [IsServiceCharge]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsHazMat]  DEFAULT ((0)) FOR [IsHazMat]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsHazMatOrmd]  DEFAULT ((0)) FOR [IsHazMatOrmd]
GO
ALTER TABLE [dbo].[SLCShipmentDetail] ADD  CONSTRAINT [DF_SLCShipmentDetail_IsCommodity]  DEFAULT ((1)) FOR [IsCommodity]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsVoidIndicator]  DEFAULT ((0)) FOR [IsVoidIndicator]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_NumberOfParcels]  DEFAULT ((0)) FOR [NumberOfParcels]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_PCId]  DEFAULT ('') FOR [StationId]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsFreeFreight]  DEFAULT ((0)) FOR [IsFreeFreight]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsMultiOrder]  DEFAULT ((0)) FOR [IsMultiOrder]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsSplitDutyTaxTo]  DEFAULT ((0)) FOR [IsSplitDutyTaxTo]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsHandlingCharge]  DEFAULT ((0)) FOR [IsHandlingCharge]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsCarrierDv]  DEFAULT ((0)) FOR [IsCarrierDv]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsShipperPayDv]  DEFAULT ((0)) FOR [IsShipperPayDv]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsAltDv]  DEFAULT ((0)) FOR [IsAltDv]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsReturnService]  DEFAULT ((0)) FOR [IsReturnService]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsSaturdayDel]  DEFAULT ((0)) FOR [IsSaturdayDel]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsSaturdayPickup]  DEFAULT ((0)) FOR [IsSaturdayPickup]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsSundayDel]  DEFAULT ((0)) FOR [IsSundayDel]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsSundayPickup]  DEFAULT ((0)) FOR [IsSundayPickup]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDelConfirmSig]  DEFAULT ((0)) FOR [IsDelConfirmSig]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDelConfirmNoSig]  DEFAULT ((0)) FOR [IsDelConfirmNoSig]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDelConfirmAdultSig]  DEFAULT ((0)) FOR [IsDelConfirmAdultSig]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDelConfirmDirectSig]  DEFAULT ((0)) FOR [IsDelConfirmDirectSig]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDelConfirmIndirectSig]  DEFAULT ((0)) FOR [IsDelConfirmIndirectSig]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsCOD]  DEFAULT ((0)) FOR [IsCOD]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsCheckMoneyOrder]  DEFAULT ((0)) FOR [IsCheckMoneyOrder]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsAddShippingCharges]  DEFAULT ((0)) FOR [IsAddShippingCharges]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsElecCOD]  DEFAULT ((0)) FOR [IsElecCOD]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsDocumentsOnly]  DEFAULT ((0)) FOR [IsDocumentsOnly]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsResidential]  DEFAULT ((0)) FOR [IsResidential]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsFreight]  DEFAULT ((0)) FOR [IsFreight]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsLTL]  DEFAULT ((0)) FOR [IsLTL]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsAutoPickAndShip]  DEFAULT ((0)) FOR [IsAutoPickAndShip]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsShipLinkConsolidation]  DEFAULT ((0)) FOR [IsShipLinkConsolidation]
GO
ALTER TABLE [dbo].[SLCShipmentInformation] ADD  CONSTRAINT [DF_SLCShipmentInformation_IsCrossBorderConsolidation]  DEFAULT ((0)) FOR [IsCrossBorderConsolidation]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_EODShipmentPackage_CaseNumber]  DEFAULT ([dbo].[ufn_SLCCaseNumber]()) FOR [CaseNumber]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsCarrierDV]  DEFAULT ((0)) FOR [IsCarrierDV]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsAltDV]  DEFAULT ((0)) FOR [IsAltDV]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsShipperPayDv]  DEFAULT ((0)) FOR [IsShipperPayDv]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsCod]  DEFAULT ((0)) FOR [IsCod]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsCheckMoneyOrder]  DEFAULT ((0)) FOR [IsCheckMoneyOrder]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsAddShippingCharges]  DEFAULT ((0)) FOR [IsAddShippingCharges]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsUspsDelConfirmation]  DEFAULT ((0)) FOR [IsUspsDelConfirmation]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsAutoPickAndShip]  DEFAULT ((0)) FOR [IsAutoPickAndShip]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsShipperRelease]  DEFAULT ((0)) FOR [IsShipperRelease]
GO
ALTER TABLE [dbo].[SLCShipmentPackage] ADD  CONSTRAINT [DF_SLCShipmentPackage_IsAddHandlingCharges]  DEFAULT ((0)) FOR [IsAddHandlingCharges]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsReq__780AAFAB]  DEFAULT ((0)) FOR [IsRequestDutiesTaxes]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsCre__79F2F81D]  DEFAULT ((0)) FOR [IsCreateAnInvoice]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsInv__7BDB408F]  DEFAULT ((0)) FOR [IsInvImporterSameAsShipTo]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsInv__7CCF64C8]  DEFAULT ((0)) FOR [IsInvImporterSameAsShipToStr]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsEEI__7DC38901]  DEFAULT ((0)) FOR [IsEEINotification]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] ADD  CONSTRAINT [DF__SLInterna__IsNAF__7FABD173]  DEFAULT ((0)) FOR [IsNAFTA]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInterna__IsDDT__019419E5]  DEFAULT ((0)) FOR [IsDDTCMilitaryEquipment]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInterna__IsDDT__037C6257]  DEFAULT ((0)) FOR [IsDDTCEligiblePartyCertif]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInterna__IsDDT__04708690]  DEFAULT ((0)) FOR [IsDDTCEligiblePartyCertifStr]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInterna__IsNAF__0564AAC9]  DEFAULT ((0)) FOR [IsNAFTAPrintGoodOnNAFTA]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInterna__IsSLI__0658CF02]  DEFAULT ((0)) FOR [IsSLIPrintGoodonSLI]
GO
ALTER TABLE [dbo].[SLInternationalGood] ADD  CONSTRAINT [DF__SLInternati__DFM__08411774]  DEFAULT ((0)) FOR [DFM]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsCarr__4F47C5E3]  DEFAULT ((0)) FOR [IsCarrierDV]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsAltD__503BEA1C]  DEFAULT ((0)) FOR [IsAltDV]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsShip__51300E55]  DEFAULT ((0)) FOR [IsShipperPayDv]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsShip__5224328E]  DEFAULT ((0)) FOR [IsShipperPayDvStr]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsCod__531856C7]  DEFAULT ((0)) FOR [IsCod]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsChec__540C7B00]  DEFAULT ((0)) FOR [IsCheckMoneyOrder]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsAddS__55009F39]  DEFAULT ((0)) FOR [IsAddShippingCharges]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsVoid__55F4C372]  DEFAULT ((0)) FOR [IsVoid]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsVoid__56E8E7AB]  DEFAULT ((0)) FOR [IsVoidStr]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsUsps__57DD0BE4]  DEFAULT ((0)) FOR [IsUspsDelConfirmation]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsUsps__58D1301D]  DEFAULT ((0)) FOR [IsUspsDelConfirmationStr]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsDelC__59C55456]  DEFAULT ((0)) FOR [IsDelConfirmSig]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsDelC__5AB9788F]  DEFAULT ((0)) FOR [IsDelConfirmNoSig]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsDelC__5BAD9CC8]  DEFAULT ((0)) FOR [IsDelConfirmAdultSig]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsDelC__5CA1C101]  DEFAULT ((0)) FOR [IsDelConfirmDirectSig]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsDelC__5D95E53A]  DEFAULT ((0)) FOR [IsDelConfirmIndirectSig]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsAuto__5E8A0973]  DEFAULT ((0)) FOR [IsAutoPickAndShip]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsShip__5F7E2DAC]  DEFAULT ((0)) FOR [IsShipperRelease]
GO
ALTER TABLE [dbo].[SLParcel] ADD  CONSTRAINT [DF__SLParcel__IsAddH__607251E5]  DEFAULT ((0)) FOR [IsAddHandlingCharges]
GO
ALTER TABLE [dbo].[SLShipTo] ADD  CONSTRAINT [DF__SLShipTo__IsPoBo__752E4300]  DEFAULT ((0)) FOR [IsPoBox]
GO
ALTER TABLE [dbo].[SLShipTo] ADD  CONSTRAINT [DF__SLShipTo__IsResi__76226739]  DEFAULT ((0)) FOR [IsResidential]
GO
ALTER TABLE [dbo].[SLASN]  WITH CHECK ADD  CONSTRAINT [FK_SLASN_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLASN] CHECK CONSTRAINT [FK_SLASN_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLCEmailDetail]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCEmailDetail_SLCShipmentByOrder] FOREIGN KEY([SLCShipmentByOrder_Id])
REFERENCES [dbo].[SLCShipmentByOrder] ([Id])
GO
ALTER TABLE [dbo].[SLCEmailDetail] CHECK CONSTRAINT [FK_SLCEmailDetail_SLCShipmentByOrder]
GO
ALTER TABLE [dbo].[SLCEventDocument]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCEventDocument_SLCDocument] FOREIGN KEY([SLCDocument_Id])
REFERENCES [dbo].[SLCDocument] ([Id])
GO
ALTER TABLE [dbo].[SLCEventDocument] CHECK CONSTRAINT [FK_SLCEventDocument_SLCDocument]
GO
ALTER TABLE [dbo].[SLCEventDocument]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCEventDocument_SLCEvent] FOREIGN KEY([SLCEvent_Id])
REFERENCES [dbo].[SLCEvent] ([Id])
GO
ALTER TABLE [dbo].[SLCEventDocument] CHECK CONSTRAINT [FK_SLCEventDocument_SLCEvent]
GO
ALTER TABLE [dbo].[SLCOutput]  WITH CHECK ADD  CONSTRAINT [FK_SLCOutput_SLCEventDocument] FOREIGN KEY([SLCEventDocument_Id])
REFERENCES [dbo].[SLCEventDocument] ([Id])
GO
ALTER TABLE [dbo].[SLCOutput] CHECK CONSTRAINT [FK_SLCOutput_SLCEventDocument]
GO
ALTER TABLE [dbo].[SLCShipmentByOrder]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCShipmentByOrder_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentByOrder] CHECK CONSTRAINT [FK_SLCShipmentByOrder_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLCShipmentDetail]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCShipmentDetail_SLCShipmentByOrder] FOREIGN KEY([SLCShipmentByOrder_Id])
REFERENCES [dbo].[SLCShipmentByOrder] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentDetail] CHECK CONSTRAINT [FK_SLCShipmentDetail_SLCShipmentByOrder]
GO
ALTER TABLE [dbo].[SLCShipmentPackage]  WITH NOCHECK ADD  CONSTRAINT [FK_SLCShipmentPackage_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentPackage] CHECK CONSTRAINT [FK_SLCShipmentPackage_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent]  WITH CHECK ADD  CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentDetail] FOREIGN KEY([SLCShipmentDetail_Id])
REFERENCES [dbo].[SLCShipmentDetail] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent] CHECK CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentDetail]
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent]  WITH CHECK ADD  CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent] CHECK CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent]  WITH CHECK ADD  CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentPackage] FOREIGN KEY([SLCShipmentPackage_Id])
REFERENCES [dbo].[SLCShipmentPackage] ([Id])
GO
ALTER TABLE [dbo].[SLCShipmentPackageContent] CHECK CONSTRAINT [FK_SLCShipmentPackageContent_SLCShipmentPackage]
GO
ALTER TABLE [dbo].[SLInternationalDocumentation]  WITH CHECK ADD  CONSTRAINT [FK_SLInternationalDocumentation_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLInternationalDocumentation] CHECK CONSTRAINT [FK_SLInternationalDocumentation_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLInternationalGood]  WITH CHECK ADD  CONSTRAINT [FK_SLInternationalGood_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLInternationalGood] CHECK CONSTRAINT [FK_SLInternationalGood_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLParcel]  WITH CHECK ADD  CONSTRAINT [FK_SLParcel_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLParcel] CHECK CONSTRAINT [FK_SLParcel_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLShipFrom]  WITH CHECK ADD  CONSTRAINT [FK_SLShipFrom_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLShipFrom] CHECK CONSTRAINT [FK_SLShipFrom_SLCShipmentInformation]
GO
ALTER TABLE [dbo].[SLShipTo]  WITH CHECK ADD  CONSTRAINT [FK_SLShipTo_SLCShipmentInformation] FOREIGN KEY([SLCShipmentInformation_Id])
REFERENCES [dbo].[SLCShipmentInformation] ([Id])
GO
ALTER TABLE [dbo].[SLShipTo] CHECK CONSTRAINT [FK_SLShipTo_SLCShipmentInformation]
GO
USE [master]
GO
ALTER DATABASE [ShipLinkCentralDB] SET  READ_WRITE 
GO